Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	4328
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	507.2 KiB
Average record size in memory	120.0 B

Variable types

Numeric	14

Alerts

`monetary` is highly overall correlated with `unique_prods` and 6 other fields	High correlation
`unique_prods` is highly overall correlated with `monetary` and 4 other fields	High correlation
`qt_prods` is highly overall correlated with `monetary` and 7 other fields	High correlation
`avg_basket_size` is highly overall correlated with `unique_prods` and 1 other fields	High correlation
`recency` is highly overall correlated with `qt_prods` and 2 other fields	High correlation
`relationship_duration` is highly overall correlated with `monetary` and 6 other fields	High correlation
`purchase_count` is highly overall correlated with `monetary` and 6 other fields	High correlation
`returns_count` is highly overall correlated with `return_rate`	High correlation
`return_rate` is highly overall correlated with `returns_count`	High correlation
`avg_purchase_interval` is highly overall correlated with `monetary` and 4 other fields	High correlation
`frequency` is highly overall correlated with `monetary` and 4 other fields	High correlation
`avg_order_value` is highly overall correlated with `monetary`	High correlation
`monetary` is highly skewed (γ1 = 21.5227491)	Skewed
`returns_count` is highly skewed (γ1 = 26.4818313)	Skewed
`avg_unit_price` is highly skewed (γ1 = 36.53614951)	Skewed
`return_rate` is highly skewed (γ1 = 40.70929296)	Skewed
`avg_purchase_interval` is highly skewed (γ1 = 59.06472112)	Skewed
`frequency` is highly skewed (γ1 = 59.06472112)	Skewed
`customer_id` has unique values	Unique
`relationship_duration` has 1555 (35.9%) zeros	Zeros
`returns_count` has 2825 (65.3%) zeros	Zeros
`return_rate` has 2825 (65.3%) zeros	Zeros
`avg_purchase_interval` has 1555 (35.9%) zeros	Zeros
`frequency` has 1555 (35.9%) zeros	Zeros

Reproduction

Analysis started	2023-06-25 22:51:24.227513
Analysis finished	2023-06-25 22:51:52.339963
Duration	28.11 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	4328
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15301.107

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	12347
5-th percentile	12616.35
Q1	13813.75
median	15299.5
Q3	16780.25
95-th percentile	17984.65
Maximum	18287
Range	5940
Interquartile range (IQR)	2966.5

Descriptive statistics

Standard deviation	1721.3706
Coefficient of variation (CV)	0.11249975
Kurtosis	-1.1957468
Mean	15301.107
Median Absolute Deviation (MAD)	1484
Skewness	0.0019049645
Sum	66223189
Variance	2963116.8
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12347	1	< 0.1%
16297	1	< 0.1%
16272	1	< 0.1%
16274	1	< 0.1%
16275	1	< 0.1%
16276	1	< 0.1%
16278	1	< 0.1%
16279	1	< 0.1%
16281	1	< 0.1%
16282	1	< 0.1%
Other values (4318)	4318	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%
12357	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18281	1	< 0.1%
18280	1	< 0.1%
18278	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%

monetary
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	4245
Distinct (%)	98.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1916.1357

Minimum	-796.86
Maximum	278778.02
Zeros	9
Zeros (%)	0.2%
Negative	3
Negative (%)	0.1%
Memory size	67.6 KiB

Quantile statistics

Minimum	-796.86
5-th percentile	109.0325
Q1	298.92
median	652.81
Q3	1610.2275
95-th percentile	5650.59
Maximum	278778.02
Range	279574.88
Interquartile range (IQR)	1311.3075

Descriptive statistics

Standard deviation	8313.9946
Coefficient of variation (CV)	4.3389382
Kurtosis	596.66174
Mean	1916.1357
Median Absolute Deviation (MAD)	453.98
Skewness	21.522749
Sum	8293035.5
Variance	69122507
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9	0.2%
76.32	4	0.1%
440	3	0.1%
113.5	3	0.1%
15	3	0.1%
363.65	3	0.1%
35.4	3	0.1%
238.85	2	< 0.1%
326.4	2	< 0.1%
204	2	< 0.1%
Other values (4235)	4294	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-796.86	1	< 0.1%
-141.48	1	< 0.1%
-95.93	1	< 0.1%
0	9	0.2%
5.684341886 × 10^-14	1	< 0.1%
4.547473509 × 10^-13	1	< 0.1%
3.75	1	< 0.1%
5.9	1	< 0.1%
12.24	1	< 0.1%
12.75	1	< 0.1%

Value	Count	Frequency (%)
278778.02	1	< 0.1%
259657.3	1	< 0.1%
189735.53	1	< 0.1%
133007.13	1	< 0.1%
123638.18	1	< 0.1%
114505.32	1	< 0.1%
88138.2	1	< 0.1%
65920.12	1	< 0.1%
62924.1	1	< 0.1%
59419.34	1	< 0.1%

unique_prods
Real number (ℝ)

Distinct	341
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.456331

Minimum	1
Maximum	1786
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	16
median	35
Q3	77
95-th percentile	204
Maximum	1786
Range	1785
Interquartile range (IQR)	61

Descriptive statistics

Standard deviation	85.364548
Coefficient of variation (CV)	1.3890277
Kurtosis	99.651934
Mean	61.456331
Median Absolute Deviation (MAD)	24
Skewness	6.917132
Sum	265983
Variance	7287.106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	93	2.1%
10	86	2.0%
8	80	1.8%
9	79	1.8%
11	78	1.8%
13	76	1.8%
5	73	1.7%
15	73	1.7%
6	73	1.7%
14	72	1.7%
Other values (331)	3545	81.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	93	2.1%
2	52	1.2%
3	60	1.4%
4	52	1.2%
5	73	1.7%
6	73	1.7%
7	72	1.7%
8	80	1.8%
9	79	1.8%
10	86	2.0%

Value	Count	Frequency (%)
1786	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
884	1	< 0.1%
817	1	< 0.1%
717	1	< 0.1%
714	1	< 0.1%
699	1	< 0.1%
636	1	< 0.1%

qt_prods
Real number (ℝ)

Distinct	468
Distinct (%)	10.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	91.537893

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	17
median	41
Q3	100
95-th percentile	314.65
Maximum	7838
Range	7837
Interquartile range (IQR)	83

Descriptive statistics

Standard deviation	228.63639
Coefficient of variation (CV)	2.4977239
Kurtosis	483.13585
Mean	91.537893
Median Absolute Deviation (MAD)	30
Skewness	18.102096
Sum	396176
Variance	52274.597
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	86	2.0%
6	78	1.8%
9	75	1.7%
1	72	1.7%
11	70	1.6%
15	70	1.6%
8	67	1.5%
5	67	1.5%
7	66	1.5%
28	65	1.5%
Other values (458)	3612	83.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	72	1.7%
2	51	1.2%
3	56	1.3%
4	48	1.1%
5	67	1.5%
6	78	1.8%
7	66	1.5%
8	67	1.5%
9	75	1.7%
10	86	2.0%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

avg_basket_size
Real number (ℝ)

Distinct	1029
Distinct (%)	23.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.291473

Minimum	1
Maximum	299.70588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2.8633929
Q1	9.4214286
median	17
Q3	28.4
95-th percentile	59.666667
Maximum	299.70588
Range	298.70588
Interquartile range (IQR)	18.978571

Descriptive statistics

Standard deviation	20.660891
Coefficient of variation (CV)	0.92685175
Kurtosis	21.194047
Mean	22.291473
Median Absolute Deviation (MAD)	8.6666667
Skewness	3.2234831
Sum	96477.495
Variance	426.87241
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	2.3%
13	93	2.1%
10	88	2.0%
9	82	1.9%
11	78	1.8%
14	77	1.8%
6	74	1.7%
7	72	1.7%
5	70	1.6%
8	69	1.6%
Other values (1019)	3526	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	99	2.3%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	< 0.1%
1.5	7	0.2%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	62	1.4%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
259	1	< 0.1%
219	1	< 0.1%
203.5	1	< 0.1%
191	1	< 0.1%
171	1	< 0.1%
164	1	< 0.1%
157	2	< 0.1%
153	1	< 0.1%
148	1	< 0.1%

recency
Real number (ℝ)

Distinct	304
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.152957

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	17
median	50
Q3	142
95-th percentile	311
Maximum	373
Range	373
Interquartile range (IQR)	125

Descriptive statistics

Standard deviation	100.20037
Coefficient of variation (CV)	1.0873266
Kurtosis	0.42457035
Mean	92.152957
Median Absolute Deviation (MAD)	40
Skewness	1.245256
Sum	398838
Variance	10040.113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	103	2.4%
3	94	2.2%
4	94	2.2%
2	90	2.1%
8	79	1.8%
10	77	1.8%
17	74	1.7%
7	72	1.7%
9	70	1.6%
22	64	1.5%
Other values (294)	3511	81.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	0.8%
1	103	2.4%
2	90	2.1%
3	94	2.2%
4	94	2.2%
5	48	1.1%
7	72	1.7%
8	79	1.8%
9	70	1.6%
10	77	1.8%

Value	Count	Frequency (%)
373	17	0.4%
372	18	0.4%
371	6	0.1%
369	3	0.1%
368	5	0.1%
367	5	0.1%
366	10	0.2%
365	10	0.2%
364	6	0.1%
362	6	0.1%

relationship_duration
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	374
Distinct (%)	8.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	130.73082

Minimum	0
Maximum	373
Zeros	1555
Zeros (%)	35.9%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	93
Q3	252
95-th percentile	357
Maximum	373
Range	373
Interquartile range (IQR)	252

Descriptive statistics

Standard deviation	132.31843
Coefficient of variation (CV)	1.0121441
Kurtosis	-1.3313579
Mean	130.73082
Median Absolute Deviation (MAD)	93
Skewness	0.4528219
Sum	565803
Variance	17508.168
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1555	35.9%
364	28	0.6%
350	26	0.6%
357	25	0.6%
366	20	0.5%
351	20	0.5%
355	19	0.4%
365	18	0.4%
343	18	0.4%
356	17	0.4%
Other values (364)	2582	59.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1555	35.9%
1	9	0.2%
2	4	0.1%
3	5	0.1%
4	4	0.1%
5	3	0.1%
6	2	< 0.1%
7	7	0.2%
8	5	0.1%
9	3	0.1%

Value	Count	Frequency (%)
373	5	0.1%
372	8	0.2%
371	8	0.2%
370	8	0.2%
369	6	0.1%
368	10	0.2%
367	11	0.3%
366	20	0.5%
365	18	0.4%
364	28	0.6%

purchase_count
Real number (ℝ)

Distinct	56
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.2518484

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	13
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	7.6516406
Coefficient of variation (CV)	1.7996033
Kurtosis	244.52051
Mean	4.2518484
Median Absolute Deviation (MAD)	1
Skewness	11.961503
Sum	18402
Variance	58.547605
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1504	34.8%
2	825	19.1%
3	503	11.6%
4	394	9.1%
5	237	5.5%
6	173	4.0%
7	138	3.2%
8	98	2.3%
9	69	1.6%
10	55	1.3%
Other values (46)	332	7.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1504	34.8%
2	825	19.1%
3	503	11.6%
4	394	9.1%
5	237	5.5%
6	173	4.0%
7	138	3.2%
8	98	2.3%
9	69	1.6%
10	55	1.3%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%
57	1	< 0.1%

returns_count
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	213
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.996765

Minimum	0
Maximum	9014
Zeros	2825
Zeros (%)	65.3%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	58.65
Maximum	9014
Range	9014
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	234.78991
Coefficient of variation (CV)	9.7842316
Kurtosis	866.92703
Mean	23.996765
Median Absolute Deviation (MAD)	0
Skewness	26.481831
Sum	103858
Variance	55126.301
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2825	65.3%
1	169	3.9%
2	150	3.5%
3	105	2.4%
4	89	2.1%
6	78	1.8%
5	61	1.4%
12	52	1.2%
7	44	1.0%
8	43	1.0%
Other values (203)	712	16.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2825	65.3%
1	169	3.9%
2	150	3.5%
3	105	2.4%
4	89	2.1%
5	61	1.4%
6	78	1.8%
7	44	1.0%
8	43	1.0%
9	41	0.9%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

avg_unit_price
Real number (ℝ)

Distinct	4176
Distinct (%)	96.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4664777

Minimum	0.1225
Maximum	434.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0.1225
5-th percentile	1.3180392
Q1	2.155125
median	2.8285824
Q3	3.7120688
95-th percentile	5.984999
Maximum	434.65
Range	434.5275
Interquartile range (IQR)	1.5569438

Descriptive statistics

Standard deviation	8.8708451
Coefficient of variation (CV)	2.5590371
Kurtosis	1579.0521
Mean	3.4664777
Median Absolute Deviation (MAD)	0.74715195
Skewness	36.53615
Sum	15002.916
Variance	78.691892
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.06	10	0.2%
1.79	8	0.2%
2.08	7	0.2%
4.95	7	0.2%
1.25	7	0.2%
2.95	6	0.1%
2.55	6	0.1%
12.75	5	0.1%
4.25	4	0.1%
0.72	4	0.1%
Other values (4166)	4264	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1225	1	< 0.1%
0.17	2	< 0.1%
0.2327777778	1	< 0.1%
0.29	2	< 0.1%
0.32	1	< 0.1%
0.358	1	< 0.1%
0.3666666667	1	< 0.1%
0.39	1	< 0.1%
0.3917241379	1	< 0.1%
0.39375	1	< 0.1%

Value	Count	Frequency (%)
434.65	1	< 0.1%
295	1	< 0.1%
125	1	< 0.1%
110	2	< 0.1%
74.975	1	< 0.1%
66.475	1	< 0.1%
59.73333333	1	< 0.1%
54.3	1	< 0.1%
51.71	1	< 0.1%
32.97142857	1	< 0.1%

return_rate
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	471
Distinct (%)	10.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.6878971

Minimum	0
Maximum	3004.6667
Zeros	2825
Zeros (%)	65.3%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	11.2
Maximum	3004.6667
Range	3004.6667
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	55.660421
Coefficient of variation (CV)	11.873217
Kurtosis	2032.7264
Mean	4.6878971
Median Absolute Deviation (MAD)	0
Skewness	40.709293
Sum	20289.219
Variance	3098.0825
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2825	65.3%
1	112	2.6%
2	81	1.9%
0.5	64	1.5%
3	52	1.2%
0.3333333333	43	1.0%
4	40	0.9%
1.5	33	0.8%
6	32	0.7%
0.25	29	0.7%
Other values (461)	1017	23.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2825	65.3%
0.03571428571	1	< 0.1%
0.04761904762	1	< 0.1%
0.05	1	< 0.1%
0.05555555556	1	< 0.1%
0.07272727273	1	< 0.1%
0.07692307692	1	< 0.1%
0.08333333333	1	< 0.1%
0.09090909091	2	< 0.1%
0.1	6	0.1%

Value	Count	Frequency (%)
3004.666667	1	< 0.1%
1228	1	< 0.1%
1006	1	< 0.1%
510	1	< 0.1%
426	1	< 0.1%
378.75	1	< 0.1%
336	1	< 0.1%
314	1	< 0.1%
312	1	< 0.1%
300	1	< 0.1%

avg_purchase_interval
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1229
Distinct (%)	28.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03962258

Minimum	0
Maximum	34
Zeros	1555
Zeros (%)	35.9%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.014925373
Q3	0.03030303
95-th percentile	0.089146825
Maximum	34
Range	34
Interquartile range (IQR)	0.03030303

Descriptive statistics

Standard deviation	0.53673128
Coefficient of variation (CV)	13.546096
Kurtosis	3710.6697
Mean	0.03962258
Median Absolute Deviation (MAD)	0.014925373
Skewness	59.064721
Sum	171.48653
Variance	0.28808046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1555	35.9%
0.07142857143	16	0.4%
0.04761904762	15	0.3%
0.02857142857	14	0.3%
0.0303030303	14	0.3%
0.01587301587	14	0.3%
0.06451612903	13	0.3%
0.02380952381	13	0.3%
0.1428571429	13	0.3%
0.025	12	0.3%
Other values (1219)	2649	61.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1555	35.9%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005602240896	2	< 0.1%
0.005617977528	1	< 0.1%
0.005633802817	2	< 0.1%
0.005681818182	1	< 0.1%
0.005698005698	2	< 0.1%

Value	Count	Frequency (%)
34	1	< 0.1%
6	1	< 0.1%
4	1	< 0.1%
2	6	0.1%
1.5	1	< 0.1%
1.333333333	2	< 0.1%
1	4	0.1%
0.6666666667	3	0.1%
0.5522788204	1	< 0.1%
0.5349462366	1	< 0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1229
Distinct (%)	28.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03962258

Minimum	0
Maximum	34
Zeros	1555
Zeros (%)	35.9%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.014925373
Q3	0.03030303
95-th percentile	0.089146825
Maximum	34
Range	34
Interquartile range (IQR)	0.03030303

Descriptive statistics

Standard deviation	0.53673128
Coefficient of variation (CV)	13.546096
Kurtosis	3710.6697
Mean	0.03962258
Median Absolute Deviation (MAD)	0.014925373
Skewness	59.064721
Sum	171.48653
Variance	0.28808046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1555	35.9%
0.07142857143	16	0.4%
0.04761904762	15	0.3%
0.02857142857	14	0.3%
0.0303030303	14	0.3%
0.01587301587	14	0.3%
0.06451612903	13	0.3%
0.02380952381	13	0.3%
0.1428571429	13	0.3%
0.025	12	0.3%
Other values (1219)	2649	61.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1555	35.9%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005602240896	2	< 0.1%
0.005617977528	1	< 0.1%
0.005633802817	2	< 0.1%
0.005681818182	1	< 0.1%
0.005698005698	2	< 0.1%

Value	Count	Frequency (%)
34	1	< 0.1%
6	1	< 0.1%
4	1	< 0.1%
2	6	0.1%
1.5	1	< 0.1%
1.333333333	2	< 0.1%
1	4	0.1%
0.6666666667	3	0.1%
0.5522788204	1	< 0.1%
0.5349462366	1	< 0.1%

avg_order_value
Real number (ℝ)

Distinct	4241
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	369.72062

Minimum	-796.86
Maximum	13206.5
Zeros	9
Zeros (%)	0.2%
Negative	3
Negative (%)	0.1%
Memory size	67.6 KiB

Quantile statistics

Minimum	-796.86
5-th percentile	85.013125
Q1	173.8975
median	282.301
Q3	420.7745
95-th percentile	890.82462
Maximum	13206.5
Range	14003.36
Interquartile range (IQR)	246.877

Descriptive statistics

Standard deviation	465.27961
Coefficient of variation (CV)	1.2584627
Kurtosis	201.77649
Mean	369.72062
Median Absolute Deviation (MAD)	118.065
Skewness	10.60863
Sum	1600150.8
Variance	216485.11
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9	0.2%
76.32	4	0.1%
120	3	0.1%
113.5	3	0.1%
35.4	3	0.1%
440	3	0.1%
326.4	2	< 0.1%
436.005	2	< 0.1%
358	2	< 0.1%
72	2	< 0.1%
Other values (4231)	4295	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-796.86	1	< 0.1%
-141.48	1	< 0.1%
-47.965	1	< 0.1%
0	9	0.2%
5.684341886 × 10^-14	1	< 0.1%
4.547473509 × 10^-13	1	< 0.1%
3.75	1	< 0.1%
5.9	1	< 0.1%
7.5	1	< 0.1%
9.14	1	< 0.1%

Value	Count	Frequency (%)
13206.5	1	< 0.1%
9338.38	1	< 0.1%
7178.633333	1	< 0.1%
6207.67	1	< 0.1%
6181.909	1	< 0.1%
4873.81	1	< 0.1%
4366.78	1	< 0.1%
4327.621667	1	< 0.1%
4314.72	1	< 0.1%
4151.26	1	< 0.1%

Auto

Heatmap
Table

	customer_id	monetary	unique_prods	qt_prods	avg_basket_size	recency	relationship_duration	purchase_count	returns_count	avg_unit_price	return_rate	avg_purchase_interval	frequency	avg_order_value
customer_id	1.000	-0.078	-0.009	-0.006	-0.004	0.008	-0.009	0.000	-0.053	-0.017	-0.056	-0.005	-0.005	-0.124
monetary	-0.078	1.000	0.734	0.788	0.313	-0.487	0.724	0.806	0.456	0.021	0.398	0.632	0.632	0.676
unique_prods	-0.009	0.734	1.000	0.983	0.744	-0.458	0.602	0.655	0.352	-0.082	0.301	0.499	0.499	0.424
qt_prods	-0.006	0.788	0.983	1.000	0.680	-0.500	0.664	0.732	0.386	-0.084	0.328	0.559	0.559	0.423
avg_basket_size	-0.004	0.313	0.744	0.680	1.000	-0.137	0.062	0.047	0.040	-0.131	0.040	0.012	0.012	0.466
recency	0.008	-0.487	-0.458	-0.500	-0.137	1.000	-0.563	-0.564	-0.254	0.096	-0.205	-0.431	-0.431	-0.133
relationship_duration	-0.009	0.724	0.602	0.664	0.062	-0.563	1.000	0.895	0.420	0.008	0.359	0.621	0.621	0.145
purchase_count	0.000	0.806	0.655	0.732	0.047	-0.564	0.895	1.000	0.476	0.005	0.403	0.805	0.805	0.154
returns_count	-0.053	0.456	0.352	0.386	0.040	-0.254	0.420	0.476	1.000	0.059	0.989	0.363	0.363	0.190
avg_unit_price	-0.017	0.021	-0.082	-0.084	-0.131	0.096	0.008	0.005	0.059	1.000	0.063	0.004	0.004	0.031
return_rate	-0.056	0.398	0.301	0.328	0.040	-0.205	0.359	0.403	0.989	0.063	1.000	0.310	0.310	0.184
avg_purchase_interval	-0.005	0.632	0.499	0.559	0.012	-0.431	0.621	0.805	0.363	0.004	0.310	1.000	1.000	0.113
frequency	-0.005	0.632	0.499	0.559	0.012	-0.431	0.621	0.805	0.363	0.004	0.310	1.000	1.000	0.113
avg_order_value	-0.124	0.676	0.424	0.423	0.466	-0.133	0.145	0.154	0.190	0.031	0.184	0.113	0.113	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	monetary	unique_prods	qt_prods	avg_basket_size	recency	relationship_duration	purchase_count	returns_count	avg_unit_price	return_rate	avg_purchase_interval	frequency	avg_order_value
0	12347.0	4310.00	103	182	26.000000	2	365	7	0.0	2.644011	0.0	0.019178	0.019178	615.714286
1	12348.0	1437.24	21	27	6.750000	75	283	4	0.0	0.692963	0.0	0.014134	0.014134	359.310000
2	12349.0	1457.55	72	72	72.000000	18	0	1	0.0	4.237500	0.0	0.000000	0.000000	1457.550000
3	12350.0	294.40	16	16	16.000000	310	0	1	0.0	1.581250	0.0	0.000000	0.000000	294.400000
4	12352.0	1265.41	57	77	11.000000	36	260	7	63.0	4.075455	9.0	0.026923	0.026923	180.772857
5	12353.0	89.00	4	4	4.000000	204	0	1	0.0	6.075000	0.0	0.000000	0.000000	89.000000
6	12354.0	1079.40	58	58	58.000000	232	0	1	0.0	4.503793	0.0	0.000000	0.000000	1079.400000
7	12355.0	459.40	13	13	13.000000	214	0	1	0.0	4.203846	0.0	0.000000	0.000000	459.400000
8	12356.0	2487.43	52	58	19.333333	22	303	3	0.0	2.946034	0.0	0.009901	0.009901	829.143333
9	12357.0	6207.67	131	131	131.000000	33	0	1	0.0	3.348626	0.0	0.000000	0.000000	6207.670000

	customer_id	monetary	unique_prods	qt_prods	avg_basket_size	recency	relationship_duration	purchase_count	returns_count	avg_unit_price	return_rate	avg_purchase_interval	frequency	avg_order_value
4318	18273.0	204.00	1	3	1.000000	2	255	3	0.0	2.550000	0.0	0.011765	0.011765	68.000000
4319	18274.0	0.00	11	11	11.000000	30	0	1	88.0	3.671818	88.0	0.000000	0.000000	0.000000
4320	18276.0	323.36	14	14	14.000000	43	0	1	2.0	2.482143	2.0	0.000000	0.000000	323.360000
4321	18277.0	97.63	8	8	8.000000	58	0	1	1.0	3.141250	1.0	0.000000	0.000000	97.630000
4322	18278.0	173.90	9	9	9.000000	73	0	1	0.0	3.283333	0.0	0.000000	0.000000	173.900000
4323	18280.0	180.60	10	10	10.000000	277	0	1	0.0	4.765000	0.0	0.000000	0.000000	180.600000
4324	18281.0	80.82	7	7	7.000000	180	0	1	0.0	5.622857	0.0	0.000000	0.000000	80.820000
4325	18282.0	176.60	12	12	6.000000	7	119	2	5.0	5.199167	2.5	0.016807	0.016807	88.300000
4326	18283.0	2088.93	262	754	47.125000	3	334	16	0.0	1.611379	0.0	0.047904	0.047904	130.558125
4327	18287.0	1837.28	59	70	23.333333	42	159	3	0.0	1.493571	0.0	0.018868	0.018868	612.426667

Overview

Variables

Interactions

Correlations

Missing values

Sample